/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package myprogramui.comp.page1comp;

import Globals.AllGlobal;
import controller.MyController;
import database.operate.OperateMyDatabaseImpl;
import java.io.FileOutputStream;
import java.util.ArrayList;
import java.util.Date;
import model.GongZuoMian_Model;
import model.ZuanChang_Model;
import model.ZuanKong_Model;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.ss.usermodel.Font;
import org.apache.poi.xssf.usermodel.XSSFCellStyle;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

/**
 *
 * @author Administrator
 */
public class SaveExcel {
    private String filepath;
    private HSSFWorkbook hssfw=new HSSFWorkbook();
    private XSSFWorkbook xssfw=new XSSFWorkbook();
    private HSSFSheet gZMSheet;
    private HSSFSheet zCSheet;
    private HSSFSheet zKSheet;
    private XSSFSheet gZMXSheet;
    private XSSFSheet zCXSheet;
    private XSSFSheet zKXSheet;
    private int suffixXlsI=0;
    private int suffixXlsxI=1;
    private int suffixTypeI=0;
    public SaveExcel(String filepath){
        this.filepath=filepath;
        String extName = filepath.substring(filepath.lastIndexOf(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("."))+1);
        gZMSheet=hssfw.createSheet(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("工作面"));
        zCSheet=hssfw.createSheet(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("钻场"));
        zKSheet=hssfw.createSheet(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("钻孔"));
        gZMXSheet=xssfw.createSheet(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("工作面"));
        zCXSheet=xssfw.createSheet(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("钻场"));
        zKXSheet=xssfw.createSheet(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("钻孔"));
        initWB();
        if(extName.equals(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("XLS"))){
            suffixTypeI=suffixXlsI;
        }else if(extName.equals(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("XLSX"))){
            suffixTypeI=suffixXlsxI;
        }else{
           suffixTypeI=suffixXlsxI; 
        }
    }
    public void saveData() throws Exception{
        if(suffixTypeI==suffixXlsI){
            String tmp=filepath+java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("X");
            hssfw.write(new FileOutputStream(tmp));
        }else{
            xssfw.write(new FileOutputStream(filepath));
        }
    }
    public void addAll() throws Exception{
        HSSFCellStyle cellStyle = hssfw.createCellStyle(); //建立新的cell样式 
        cellStyle.setWrapText(true);
        cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
        Font font = hssfw.createFont();
        font.setFontName(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("楷体"));
        font.setColor(HSSFColor.RED.index);    //绿字
        cellStyle.setFont(font);
        XSSFCellStyle xCellStyle=xssfw.createCellStyle();
        xCellStyle.setWrapText(true);
        xCellStyle.setAlignment(XSSFCellStyle.ALIGN_CENTER);
        xCellStyle.setFont(font);
        if(suffixTypeI==suffixXlsI){
            ArrayList<GongZuoMian_Model> gzmList=OperateMyDatabaseImpl.getAllResult(AllGlobal.GONGZUOMIAN_SQL);
            for (int i=0;i<gzmList.size();i++) {
                GongZuoMian_Model gongZuoMian_Model=gzmList.get(i);
                HSSFRow gzmDataRow=gZMSheet.createRow(i+1);
                gzmDataRow.createCell(0).setCellValue(gongZuoMian_Model.getMingcheng());        
                gzmDataRow.createCell(1).setCellValue(Float.parseFloat(gongZuoMian_Model.getZhitu()));   
                gzmDataRow.createCell(2).setCellValue(new Date(Long.valueOf(gongZuoMian_Model.getZhituriqi())));   
                gzmDataRow.createCell(3).setCellValue(gongZuoMian_Model.getHedui());   
                gzmDataRow.createCell(4).setCellValue(gongZuoMian_Model.getBilichiString());   
                gzmDataRow.createCell(5).setCellValue(gongZuoMian_Model.getKezhang());   
                gzmDataRow.createCell(6).setCellValue(gongZuoMian_Model.getBianhao());   
                gzmDataRow.createCell(7).setCellValue(gongZuoMian_Model.getGongchengshi());   
                gzmDataRow.createCell(8).setCellValue(gongZuoMian_Model.getCaichang());   
                gzmDataRow.createCell(9).setCellValue(Float.parseFloat(gongZuoMian_Model.getGzmcd()));   
                gzmDataRow.createCell(10).setCellValue(Float.parseFloat(gongZuoMian_Model.getGzmzxcdString()));   
                gzmDataRow.createCell(11).setCellValue(Float.parseFloat(gongZuoMian_Model.getGzmgszbX()));   
                gzmDataRow.createCell(12).setCellValue(Float.parseFloat(gongZuoMian_Model.getGzmgszbY()));   
                gzmDataRow.createCell(13).setCellValue(Float.parseFloat(gongZuoMian_Model.getGzmfwj()));
                gzmDataRow.createCell(14).setCellValue(Float.parseFloat(gongZuoMian_Model.getAhcjl()));
                gzmDataRow.createCell(15).setCellValue(Float.parseFloat(gongZuoMian_Model.getSgqsgszbx()));
                gzmDataRow.createCell(16).setCellValue(Float.parseFloat(gongZuoMian_Model.getSgqsgszby()));
            }
            ArrayList<ZuanChang_Model> zcList=OperateMyDatabaseImpl.getAllResult(AllGlobal.ZUANCHANG_SQL);
            for(int j=0;j<zcList.size();j++){
                ZuanChang_Model zuanChang_Model=zcList.get(j);
                HSSFRow zCDataRow = zCSheet.createRow(j+1);
                zCDataRow.createCell(0).setCellValue(zuanChang_Model.getMingcheng());
                zCDataRow.createCell(1).setCellValue(Float.parseFloat(zuanChang_Model.getShendu()));
                zCDataRow.createCell(2).setCellValue(Float.parseFloat(zuanChang_Model.getXdzbx()));
                zCDataRow.createCell(3).setCellValue(Float.parseFloat(zuanChang_Model.getXdzby()));
                zCDataRow.createCell(4).setCellValue(zuanChang_Model.getGongzuomian());
                zCDataRow.createCell(6).setCellValue(Float.parseFloat(zuanChang_Model.getYanzhanxing()));
                zCDataRow.createCell(7).setCellValue(Float.parseFloat(zuanChang_Model.getKongxilvString()));
            }
            ArrayList<ZuanKong_Model> zkList=OperateMyDatabaseImpl.getAllResult(AllGlobal.ZUANKONG_SQL);
            for(int k=0;k<zkList.size();k++){
                ZuanKong_Model zuanKong_Model=zkList.get(k);
                HSSFRow zKDataRow = zKSheet.createRow(k+1);
                zKDataRow.createCell(0).setCellValue(zuanKong_Model.getMingcheng());
                zKDataRow.createCell(1).setCellValue(Float.parseFloat(zuanKong_Model.getFangwei()));
                zKDataRow.createCell(2).setCellValue(-1*Float.parseFloat(zuanKong_Model.getQingjiao()));
                zKDataRow.createCell(3).setCellValue(Float.parseFloat(zuanKong_Model.getChengkong()));
                zKDataRow.createCell(4).setCellValue(Float.parseFloat(zuanKong_Model.getZhujiangqian()));
                zKDataRow.createCell(5).setCellValue(Float.parseFloat(zuanKong_Model.getShuiya()));
                zKDataRow.createCell(6).setCellValue(Float.parseFloat(zuanKong_Model.getKongshen()));
                zKDataRow.createCell(7).setCellValue(Float.parseFloat(zuanKong_Model.getVa()));
                zKDataRow.createCell(8).setCellValue(Float.parseFloat(zuanKong_Model.getVb()));
                zKDataRow.createCell(9).setCellValue(Float.parseFloat(zuanKong_Model.getVc()));
                zKDataRow.createCell(10).setCellValue(Float.parseFloat(zuanKong_Model.getNiantu()));
                zKDataRow.createCell(11).setCellValue(Float.parseFloat(zuanKong_Model.getShuini()));
                zKDataRow.createCell(12).setCellValue(Float.parseFloat(zuanKong_Model.getZhongya()));
                zKDataRow.createCell(13).setCellValue(zuanKong_Model.getBeizhu());
                zKDataRow.createCell(14).setCellValue(zuanKong_Model.getZuanchang());
                zKDataRow.createCell(15).setCellValue(Float.parseFloat(zuanKong_Model.getChushuidianshuipingtouying()));
            }
        }else{
            ArrayList<GongZuoMian_Model> gzmList=OperateMyDatabaseImpl.getAllResult(AllGlobal.GONGZUOMIAN_SQL);
            for (int i=0;i<gzmList.size();i++) {
                GongZuoMian_Model gongZuoMian_Model=gzmList.get(i);
                XSSFRow gzmXDataRow=gZMXSheet.createRow(i+1);
                gzmXDataRow.createCell(0).setCellValue(gongZuoMian_Model.getMingcheng());        
                gzmXDataRow.createCell(1).setCellValue(gongZuoMian_Model.getZhitu());   
                gzmXDataRow.createCell(2).setCellValue(new Date(Long.valueOf(gongZuoMian_Model.getZhituriqi())));   
                gzmXDataRow.createCell(3).setCellValue(gongZuoMian_Model.getHedui());   
                gzmXDataRow.createCell(4).setCellValue(gongZuoMian_Model.getBilichiString());   
                gzmXDataRow.createCell(5).setCellValue(gongZuoMian_Model.getKezhang());   
                gzmXDataRow.createCell(6).setCellValue(gongZuoMian_Model.getBianhao());   
                gzmXDataRow.createCell(7).setCellValue(gongZuoMian_Model.getGongchengshi());   
                gzmXDataRow.createCell(8).setCellValue(gongZuoMian_Model.getCaichang());   
                gzmXDataRow.createCell(9).setCellValue(Float.parseFloat(gongZuoMian_Model.getGzmcd()));   
                gzmXDataRow.createCell(10).setCellValue(Float.parseFloat(gongZuoMian_Model.getGzmzxcdString()));   
                gzmXDataRow.createCell(11).setCellValue(Float.parseFloat(gongZuoMian_Model.getGzmgszbX()));   
                gzmXDataRow.createCell(12).setCellValue(Float.parseFloat(gongZuoMian_Model.getGzmgszbY()));   
                gzmXDataRow.createCell(13).setCellValue(Float.parseFloat(gongZuoMian_Model.getGzmfwj()));
                gzmXDataRow.createCell(14).setCellValue(Float.parseFloat(gongZuoMian_Model.getAhcjl()));
                gzmXDataRow.createCell(15).setCellValue(Float.parseFloat(gongZuoMian_Model.getSgqsgszbx()));
                gzmXDataRow.createCell(16).setCellValue(Float.parseFloat(gongZuoMian_Model.getSgqsgszby()));
            }
            ArrayList<ZuanChang_Model> zcList=OperateMyDatabaseImpl.getAllResult(AllGlobal.ZUANCHANG_SQL);
            for(int j=0;j<zcList.size();j++){
                ZuanChang_Model zuanChang_Model=zcList.get(j);
                XSSFRow zCXDataRow = zCXSheet.createRow(j+1);
                zCXDataRow.createCell(0).setCellValue(zuanChang_Model.getMingcheng());
                zCXDataRow.createCell(1).setCellValue(Float.parseFloat(zuanChang_Model.getShendu()));
                zCXDataRow.createCell(2).setCellValue(Float.parseFloat(zuanChang_Model.getXdzbx()));
                zCXDataRow.createCell(3).setCellValue(Float.parseFloat(zuanChang_Model.getXdzby()));
                zCXDataRow.createCell(4).setCellValue(zuanChang_Model.getGongzuomian());
                zCXDataRow.createCell(5).setCellValue(Float.parseFloat(zuanChang_Model.getYanzhanxing()));
                zCXDataRow.createCell(6).setCellValue(Float.parseFloat(zuanChang_Model.getKongxilvString()));
            }
            ArrayList<ZuanKong_Model> zkList=OperateMyDatabaseImpl.getAllResult(AllGlobal.ZUANKONG_SQL);
            for(int k=0;k<zkList.size();k++){
                ZuanKong_Model zuanKong_Model=zkList.get(k);
                XSSFRow zKXDataRow = zKXSheet.createRow(k+1);

                zKXDataRow.createCell(0).setCellValue(zuanKong_Model.getMingcheng());
                zKXDataRow.createCell(1).setCellValue(Float.parseFloat(zuanKong_Model.getFangwei()));
                zKXDataRow.createCell(2).setCellValue(-1*Float.parseFloat(zuanKong_Model.getQingjiao()));
                zKXDataRow.createCell(3).setCellValue(Float.parseFloat(zuanKong_Model.getChengkong()));
                zKXDataRow.createCell(4).setCellValue(Float.parseFloat(zuanKong_Model.getZhujiangqian()));
                zKXDataRow.createCell(5).setCellValue(Float.parseFloat(zuanKong_Model.getShuiya()));
                zKXDataRow.createCell(6).setCellValue(Float.parseFloat(zuanKong_Model.getKongshen()));
                zKXDataRow.createCell(7).setCellValue(Float.parseFloat(zuanKong_Model.getVa()));
                zKXDataRow.createCell(8).setCellValue(Float.parseFloat(zuanKong_Model.getVb()));
                zKXDataRow.createCell(9).setCellValue(Float.parseFloat(zuanKong_Model.getVc()));
                zKXDataRow.createCell(10).setCellValue(Float.parseFloat(zuanKong_Model.getNiantu()));
                zKXDataRow.createCell(11).setCellValue(Float.parseFloat(zuanKong_Model.getShuini()));
                zKXDataRow.createCell(12).setCellValue(Float.parseFloat(zuanKong_Model.getZhongya()));
                zKXDataRow.createCell(13).setCellValue(zuanKong_Model.getBeizhu());
                zKXDataRow.createCell(14).setCellValue(zuanKong_Model.getZuanchang());
                zKXDataRow.createCell(15).setCellValue(Float.parseFloat(zuanKong_Model.getChushuidianshuipingtouying()));
            }
        }       
    }
    public void initWB(){
        
        HSSFRow gZMTitleRow = gZMSheet.createRow(0); 
        gZMTitleRow.createCell(0).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("工作面名称"));        
        gZMTitleRow.createCell(1).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("制图"));   
        gZMTitleRow.createCell(2).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("制图日期"));   
        gZMTitleRow.createCell(3).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("核对"));   
        gZMTitleRow.createCell(4).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("比例尺"));   
        gZMTitleRow.createCell(5).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("科长"));   
        gZMTitleRow.createCell(6).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("编号"));   
        gZMTitleRow.createCell(7).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("总工程师"));   
        gZMTitleRow.createCell(8).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("采场名称"));   
        gZMTitleRow.createCell(9).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("工作面长度"));   
        gZMTitleRow.createCell(10).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("顺槽长度"));   
        gZMTitleRow.createCell(11).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("工作面高斯坐标X"));   
        gZMTitleRow.createCell(12).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("工作面高斯坐标Y"));   
        gZMTitleRow.createCell(13).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("工作面方位角")); 
        gZMTitleRow.createCell(14).setCellValue("奥灰层距离（m）");
        gZMTitleRow.createCell(15).setCellValue("栅格起始高斯坐标X");
        gZMTitleRow.createCell(16).setCellValue("栅格起始高斯坐标Y");
        
        HSSFCellStyle cellStyle = hssfw.createCellStyle(); //建立新的cell样式 
        cellStyle.setWrapText(true);
        cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
        Font font = hssfw.createFont();
        font.setFontName(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("楷体"));
        font.setColor(HSSFColor.GREEN.index);    //绿字
        cellStyle.setFont(font);

        HSSFRow zCTitleRow = zCSheet.createRow(0);
        zCTitleRow.createCell(0).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("钻场名称"));
        zCTitleRow.createCell(1).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("深度"));
        zCTitleRow.createCell(2).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("相对坐标X"));
        zCTitleRow.createCell(3).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("相对坐标Y"));
        zCTitleRow.createCell(4).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("工作面名称"));
        zCTitleRow.createCell(5).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("延展性"));
        zCTitleRow.createCell(6).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("孔隙率"));


        HSSFRow zKTitleRow = zKSheet.createRow(0);
        zKTitleRow.createCell(0).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("钻孔名称"));
        zKTitleRow.createCell(1).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("方位角"));
        zKTitleRow.createCell(2).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("倾角"));
        zKTitleRow.createCell(3).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("成孔"));
        zKTitleRow.createCell(4).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("注浆前"));
        zKTitleRow.createCell(5).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("水压"));
        zKTitleRow.createCell(6).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("钻深"));
        zKTitleRow.createCell(7).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("V1"));
        zKTitleRow.createCell(8).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("V2"));
        zKTitleRow.createCell(9).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("V3"));
        zKTitleRow.createCell(10).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("粘土"));
        zKTitleRow.createCell(11).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("水泥"));
        zKTitleRow.createCell(12).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("终压"));
        zKTitleRow.createCell(13).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("备注"));
        zKTitleRow.createCell(14).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("钻场名称"));
        zKTitleRow.createCell(15).setCellValue("出水点（输入出水点距离钻孔打眼处的水平投影距离）");
        
        
        ///////////////////////////////////////////////
        
        XSSFRow gZMXTitleRow = gZMXSheet.createRow(0); 
        gZMXTitleRow.createCell(0).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("工作面名称"));        
        gZMXTitleRow.createCell(1).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("制图"));   
        gZMXTitleRow.createCell(2).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("制图日期"));   
        gZMXTitleRow.createCell(3).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("核对"));   
        gZMXTitleRow.createCell(4).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("比例尺"));   
        gZMXTitleRow.createCell(5).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("科长"));   
        gZMXTitleRow.createCell(6).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("编号"));   
        gZMXTitleRow.createCell(7).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("总工程师"));   
        gZMXTitleRow.createCell(8).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("采场名称"));   
        gZMXTitleRow.createCell(9).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("工作面长度"));   
        gZMXTitleRow.createCell(10).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("顺槽长度"));   
        gZMXTitleRow.createCell(11).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("工作面高斯坐标X"));   
        gZMXTitleRow.createCell(12).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("工作面高斯坐标Y"));   
        gZMXTitleRow.createCell(13).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("工作面方位角"));   
        gZMXTitleRow.createCell(14).setCellValue("奥灰层距离（m）");
        gZMXTitleRow.createCell(15).setCellValue("栅格起始高斯坐标X");
        gZMXTitleRow.createCell(16).setCellValue("栅格起始高斯坐标Y");
        
        XSSFRow zCXTitleRow = zCXSheet.createRow(0);
        zCXTitleRow.createCell(0).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("钻场名称"));
        zCXTitleRow.createCell(1).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("深度"));
        zCXTitleRow.createCell(2).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("相对坐标X"));
        zCXTitleRow.createCell(3).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("相对坐标Y"));
        zCXTitleRow.createCell(4).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("工作面名称"));
        zCXTitleRow.createCell(5).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("延展性"));
        zCXTitleRow.createCell(6).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("孔隙率"));


        XSSFRow zKXTitleRow = zKXSheet.createRow(0);
        zKXTitleRow.createCell(0).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("钻孔名称"));
        zKXTitleRow.createCell(1).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("方位角"));
        zKXTitleRow.createCell(2).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("倾角"));
        zKXTitleRow.createCell(3).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("成孔"));
        zKXTitleRow.createCell(4).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("注浆前"));
        zKXTitleRow.createCell(5).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("水压"));
        zKXTitleRow.createCell(6).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("钻深"));
        zKXTitleRow.createCell(7).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("V1"));
        zKXTitleRow.createCell(8).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("V2"));
        zKXTitleRow.createCell(9).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("V3"));
        zKXTitleRow.createCell(10).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("粘土"));
        zKXTitleRow.createCell(11).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("水泥"));
        zKXTitleRow.createCell(12).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("终压"));
        zKXTitleRow.createCell(13).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("备注"));
        zKXTitleRow.createCell(14).setCellValue(java.util.ResourceBundle.getBundle("myproj/globalizefile").getString("钻场名称"));
        zKXTitleRow.createCell(15).setCellValue("出水点（输入出水点距离钻孔打眼处的水平投影距离）");
    }

    public String getFilepath() {
        return filepath;
    }

    public void setFilepath(String filepath) {
        this.filepath = filepath;
    }
    
}
